package pers.kw.server.persist.dao;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import pers.kw.server.persist.entity.StorageDO;

public interface StorageDao extends JpaRepository<StorageDO,Long> {

    @Query(value = "from StorageDO where yn=1 and goodsNo=:goodsNo")
    StorageDO findByGoodsNo(@Param("goodsNo")String goodsNo);
}
